UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fzk6Vv/VzHTIcubo8VkG1CswKmuT3y94+5jsgwqJMqA='
WHERE
key_id = 'e0b6bee84f1d5c3705e72851ca22910656a8757a4d58edf72423f666c3cff08a'
AND (
token = 'fzk6Vv/VzHTIcubo8VkG1CswKmuT3y94+5jsgwqJMqA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)