UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WhOCA91pOu5Uhuaa5fLzUWjQ0WaEkgLzIiadAiNbZug='
WHERE
key_id = 'abd473074fd6b7a8cd49f258aaed4496cdc372b2a3d68f86ffdbb8b275904de1'
AND (
token = 'WhOCA91pOu5Uhuaa5fLzUWjQ0WaEkgLzIiadAiNbZug='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)