UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bOgNqCz64a58cZOBDOuIex+QB6EmGlfXUA6rwXz3p08='
WHERE
key_id = 'edb2c837f2b26cd18c161c075cf04224a04bf419a5e89c0116a8ddd60b2b3e5a'
AND (
token = 'bOgNqCz64a58cZOBDOuIex+QB6EmGlfXUA6rwXz3p08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)