UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qX/hLv1+PKrYGG00xmGfpF3mU4nfBaOi1uCof7zEA08='
WHERE
key_id = 'c1383745890b8976befdd0e977c745fcdbf4f9fc13f48a4af4a870a5a5477aca'
AND (
token = 'qX/hLv1+PKrYGG00xmGfpF3mU4nfBaOi1uCof7zEA08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)