UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hmb4lZL8QEqjAPlbJnfxvXxYRVfwGYnsOT8VkNdlufs='
WHERE
key_id = '5a9ddd6b338c889befb86b6e40613b3d4af9b892fed06d02cf29bd8f3a455d40'
AND (
token = 'hmb4lZL8QEqjAPlbJnfxvXxYRVfwGYnsOT8VkNdlufs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)