UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LmBj4ZBBT8twQtOYKAEBnzxMMyeGJMTSOgCvqMCM6s0='
WHERE
key_id = '11bc7989ceb3f468e84cae6f21f3eb6bcf312f74bda4261a041ade94b1bb772a'
AND (
token = 'LmBj4ZBBT8twQtOYKAEBnzxMMyeGJMTSOgCvqMCM6s0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)