UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'phzaG3S+z777ItlgzG2qY04l2LUA6hSoQUqHJPxo3LE='
WHERE
key_id = '872a10ae2a289de5819f8b3797ddf8f6ad375bef9db62e60e3488713677a780c'
AND (
token = 'phzaG3S+z777ItlgzG2qY04l2LUA6hSoQUqHJPxo3LE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)