UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MgZ5WYgPzqkLI6T5lXr38vSrOvANEICA0bGGIS6kbD8='
WHERE
key_id = '6b164bbc4806150991ef614e430ff8797d32f9e833624a6986cd7ace0978fe30'
AND (
token = 'MgZ5WYgPzqkLI6T5lXr38vSrOvANEICA0bGGIS6kbD8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)