UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'TRcYU7ZWOqaqDL9+p/grwQEFjjeJbwkIff1bWXNKVRU='
WHERE
key_id = 'fe0f2413ff9e05387d84cfe15ae6eb138822817e50e6aec7524845fac0e02060'
AND (
token = 'TRcYU7ZWOqaqDL9+p/grwQEFjjeJbwkIff1bWXNKVRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)