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