UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cOZOTgh+OUuPgH3lhLc6sJF1hOA/CCRix2H2lvBCh/4='
WHERE
key_id = '4ab1d58541a9bebe01e347281219c1bf018de975384cf7dc3f282b245f4b7b2c'
AND (
token = 'cOZOTgh+OUuPgH3lhLc6sJF1hOA/CCRix2H2lvBCh/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)