UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r8tZpqDqSkmPift0x4EL0w1pzksNm/9lG7dcUYyMOYE='
WHERE
key_id = 'ca593d170077af20f019521cbe864b554ff3d0d8ac0b9cfe259c9873639603d5'
AND (
token = 'r8tZpqDqSkmPift0x4EL0w1pzksNm/9lG7dcUYyMOYE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)