UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sIrtxzlEoeJElzy1PkK7dKc+ndF2NSKmHyDxeTKBuqQ='
WHERE
key_id = 'c1a3d0b1d2384110a375f168e8254a676381f30a450a9546fec3244ddf62024e'
AND (
token = 'sIrtxzlEoeJElzy1PkK7dKc+ndF2NSKmHyDxeTKBuqQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)