UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RIp1BVnvaKGHNvnVUHsApsc+eW4+0e19DQyA+2WzDKQ='
WHERE
key_id = 'b27c9f1019c504e1b9925085dc5cb84731d8501ddfa9f37217168fbdbd0ce2d9'
AND (
token = 'RIp1BVnvaKGHNvnVUHsApsc+eW4+0e19DQyA+2WzDKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)