UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uXc8MY+mtkyK1KyZMXvetwwHpbAPDe/gvUxEz3gyRGM='
WHERE
key_id = 'fa827da6605ff7279c0b1a27f926993147577ebdb80011dd69680b4da2f97165'
AND (
token = 'uXc8MY+mtkyK1KyZMXvetwwHpbAPDe/gvUxEz3gyRGM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)