UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'J8FyCzhk1O2QiUmdrHJ0v44z57poD9fAI00mSR6fik8='
WHERE
key_id = 'af0d7282e8debe6e50d0f07b4b745d817f97d481e6cf7151a78a595304550df8'
AND (
token = 'J8FyCzhk1O2QiUmdrHJ0v44z57poD9fAI00mSR6fik8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)