UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 't+j1ICE7XPJqzgH3T3c4bIqy5uGx8xro6ksVDu3TuqQ='
WHERE
key_id = 'a8f04491810ed56e324ed10fdfa45b10f06816150d29ba8e6b6abab5a04efef6'
AND (
token = 't+j1ICE7XPJqzgH3T3c4bIqy5uGx8xro6ksVDu3TuqQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)