UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xmod1nQBstGdTxgsclDjPy6FWslw6ZFuwh9fa+E0ppk='
WHERE
key_id = '7fc01770dc175340a5d1a1c1dc30a3e6c44290f58cf78c59919cfa5109006f66'
AND (
token = 'xmod1nQBstGdTxgsclDjPy6FWslw6ZFuwh9fa+E0ppk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)