UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R2Psi16ciElEafgE+W5k8JpQhIybemlJ5YhdbHe+V2g='
WHERE
key_id = 'b16a0d87b8473709738907309ac1caae3d4f06d76530064815a62d260ea0773c'
AND (
token = 'R2Psi16ciElEafgE+W5k8JpQhIybemlJ5YhdbHe+V2g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)