UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'K0oUzcXF9kdrlROxelErz+ApugVJHiV6hc5Idd3QwyE='
WHERE
key_id = '40ac9b4786803d3fa8194b1258082d96ca62e713438ff383f9ca573400fc0ea7'
AND (
token = 'K0oUzcXF9kdrlROxelErz+ApugVJHiV6hc5Idd3QwyE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)