UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'M6wPVdX7lNgLSD05C+k6O5XStLVd0MnZaIaj4jhIuto='
WHERE
key_id = 'c8d6893c7e50b22f6c8d1b2fbf8712e141290291e6f77890b29a253dc79d974e'
AND (
token = 'M6wPVdX7lNgLSD05C+k6O5XStLVd0MnZaIaj4jhIuto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)