UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lfQwiw6sZZorlHaHMqxI9nH/U2EEIh9HHMIguFuT4LE='
WHERE
key_id = '142ebda010054891c381a5df7595edf0d357f19da4cf53cff85ae164d3f17ea6'
AND (
token = 'lfQwiw6sZZorlHaHMqxI9nH/U2EEIh9HHMIguFuT4LE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)