UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HHwhIZyd8ahfgF0JvqlahmElffUCNqvOr9YcDb7+cD8='
WHERE
key_id = 'ef06b6f3438a188d80e1eaccfd021e1d6e2a77f25895ed1c54db559547d749c0'
AND (
token = 'HHwhIZyd8ahfgF0JvqlahmElffUCNqvOr9YcDb7+cD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)