UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GWZXJLjo36Y5Yi79lKIQ2RoHhInfjwOPIAA14WJemRU='
WHERE
key_id = '0627a4cab2ac2b44d3e79eacc6f230308c0ab1d4ba5e2f254e7611df108cf897'
AND (
token = 'GWZXJLjo36Y5Yi79lKIQ2RoHhInfjwOPIAA14WJemRU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)