UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zyen3Jvb1H8LRbGBlUCQdedOWJ54FtNgjUYjiaWG21I='
WHERE
key_id = 'a64a4721127fbf28c42ffccf676916550ffb76af4784932bd2486abe2f77b50e'
AND (
token = 'Zyen3Jvb1H8LRbGBlUCQdedOWJ54FtNgjUYjiaWG21I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)