UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qc9qKOzgf2steSMRkAxWP9xSQ49JHDkAam26ZN2oJzE='
WHERE
key_id = '26e34d8e3c83f1d1c86e0d9a8c69fecce63668ff9a161b312b17e7e3f6ea821d'
AND (
token = 'Qc9qKOzgf2steSMRkAxWP9xSQ49JHDkAam26ZN2oJzE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)