UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zCXOyilqRt63/Wgr5crTkuOPtp404fKN2MbjTpI2ALU='
WHERE
key_id = 'bc0cb490ed66be67b309d03adc283e6ff202364cc1e5d3abe9d04acbbe18d955'
AND (
token = 'zCXOyilqRt63/Wgr5crTkuOPtp404fKN2MbjTpI2ALU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)