UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZiYr1uvxou36bETkNJqjHqNvgboTATzl5fzJdQEaJ6I='
WHERE
key_id = '278a6efd6321d254f11ae6a7a6caa093b6f05bcc4721dc8b514c23c2b121bde6'
AND (
token = 'ZiYr1uvxou36bETkNJqjHqNvgboTATzl5fzJdQEaJ6I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)