UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gCKzkHlVn6Mw0wQhBpMDMs5ogWhmugOLbcZ7+HY+38g='
WHERE
key_id = 'ea1ff5a3776278208897ae1905e70db292f12fed5138829bd68208c25aa7b221'
AND (
token = 'gCKzkHlVn6Mw0wQhBpMDMs5ogWhmugOLbcZ7+HY+38g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)