UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'abq0Pf2KV4zLBee6LGIXKrU27nG6yAZpiDO/wvulSEA='
WHERE
key_id = '27e522caf09f77a3dded023b13fefbb19405186d3ae212ba544c231bb6d90325'
AND (
token = 'abq0Pf2KV4zLBee6LGIXKrU27nG6yAZpiDO/wvulSEA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)